from django.db import models


# Create your models here.

class TotalInfo(models.Model):
    id = models.AutoField(primary_key=True)
    confirm = models.IntegerField()
    heal = models.IntegerField()
    dead = models.IntegerField()
    nowConfirm = models.IntegerField()
    noInfect = models.IntegerField()
    import_count = models.IntegerField()
    append_time = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'total_info'


class ChinaDayList(models.Model):
    """
    全国累计表
    """
    id=models.AutoField(primary_key=True)
    heal = models.IntegerField()
    dead = models.IntegerField()
    confirm = models.IntegerField()
    append_time = models.CharField(default='',max_length=50)

    class Meta:
        db_table = 'china_day_list'


class ChinaDayAddList(models.Model):
    """
    全国新增表
    """
    id = models.AutoField(primary_key=True)
    confirm = models.IntegerField()
    suspect = models.IntegerField()
    importedCase = models.IntegerField()
    append_time = models.CharField(default='',max_length=50)

    class Meta:
        db_table = 'china_day_add_list'



class CountyTotal(models.Model):
    """
    全国各省累计确诊表
    """
    id = models.AutoField(primary_key=True)
    name = models.CharField(verbose_name='省份',default='',max_length=50)
    confirm = models.IntegerField(verbose_name='本土确诊数量')
    importedCase = models.IntegerField(verbose_name='境外输入数量')

    class Meta:
        db_table = 'county_total'



class HesuanList(models.Model):
    """
    全国新增表
    """
    id = models.AutoField(primary_key=True)
    title = models.IntegerField()
    area = models.CharField(default='',max_length=140)
    jtime = models.CharField(default='',max_length=140)
    jpersonname = models.CharField(default='',max_length=140)
    jpersonmobile = models.CharField(default='',max_length=140)
    jcontent = models.CharField(default='',max_length=140)
    juserid =models.IntegerField()
    jidnumer=  models.CharField(default='',max_length=140)
    hesuan_result=  models.CharField(default='',max_length=140)
    hesuan_result_uptime=  models.CharField(default='',max_length=140)
    hesuan_yangben=  models.CharField(default='',max_length=140)
    hesuan_jigou=  models.CharField(default='',max_length=140)

    
    status = models.IntegerField()

    class Meta:
        db_table = 'hesuan_list'


class Feedback(models.Model):
    """
    全国新增表
    """
    id = models.AutoField(primary_key=True)
    ftitle =models.CharField(default='',max_length=140)
    ftime = models.CharField(default='',max_length=140)
    fuser = models.CharField(default='',max_length=140)
    fcontent = models.CharField(default='',max_length=140)
    fstatus = models.IntegerField()
    class Meta:
        db_table = 'feedback'